CREATE PROCEDURE [dbo].[SeleccionarMateriasPorSemestreDePensum]
@id_Pensum int,
@numSemestre int
AS
BEGIN
	SET NOCOUNT ON;
	select m.id_Materia, m.nombreMateria, m.unidadesDeCredito
from Materia m, Pensum p, PensumMateria pm
where pm.fk_id_materia = m.id_Materia
and pm.fk_id_pensum = p.id_Pensum
and p.id_pensum = @id_Pensum
and pm.semestre = @numSemestre
	
	
	
END;